2015-11-25 - 23133 - Rel Notes - Category scorecard update - Release 002 #2015BIReleaseNotes
Release Notes:
23133 - Category scorecard update
Admin Info
Purpose
|
Need to update the category scorecard EPM260 to display top 15 customers, top 7 licences, top10 silhouettes and the rest grouped under "others".
|
Release No
|
002
|
Submitted
|
11/25/2015
|
Submitted by
|
Uday Kumar P
|
Source/Destination systems
|
BOBJ 4.1 Dev to BOBJ 4.1 Prod
|
Release Sent To
|
Saravanan Lakshmanan
|
Object(s) Created By
|
Dhananjay G
|
Object(s) Tested By
|
Uday Kumar P
|
Report Name
EPM260 - Category scorecard.
Name of the Queries
ZBPC_MP_Q001
ZBPC_MP_Q002
ZBPC_MP_Q003
ZBPC_MP_Q004
ZBPC_MP_Q006
ZBPC_MP_Q007
ZBPC_MP_Q008
ZBPC_MP_Q009
ZBPC_MP_Q010
ZBPC_MP_Q012
NEC Crystal Reports Standards Check
1. EPM260 has been successfully checked against the NEC Crystal Reports Standards Checklist.
2. EPM260 NEC CR checklist has been sent to NEC and also attached here for reference:
EPM260 - NEC CR Standard Check List.xls
Summary Level Check
Test(s) Conducted
Parameter : 1 - North America>YTD
SNo
|
Test Case
|
Value in Production Report
|
Value in Development Report
|
Pass/Fail
|
1
|
Current Year Shipped YTD
|
435,222,000
|
435,222,000.40
|
Pass
|
2
|
Last Year Shipped YTD
|
422,531,727
|
422,531,726.80
|
Pass
|
3
|
Current Year Budget YTD
|
425,334,895
|
425,334,894.83
|
Pass
|
4
|
Total Open Revenue
|
104,643,516
|
104,643,515.89
|
Pass
|
5
|
Total Shipped Current Year
|
539,865,516
|
539,865,516.29
|
Pass
|
6
|
Total Shipped Last Year
|
442,881,021
|
442,881,020.55
|
Pass
|
7
|
Total Budget Current Year
|
446,934,137
|
446,934,137.05
|
Pass
|
8
|
TY Quantity
|
43,454,871
|
43,454,871
|
Pass
|
9
|
LY Quantity
|
41,046,049
|
41,046,049
|
Pass
|
10
|
Budget Quantity
|
38,921,982
|
38,921,982
|
Pass
|
Grouping: North America > FootBall>YTD
SNo
|
Test Case
|
Value in Production Report
|
Value in Development Report
|
Pass/Fail
|
1
|
Current Year Shipped YTD
|
114,366,896
|
114,366,896.26
|
Pass
|
2
|
Last Year Shipped YTD
|
100,145,043
|
100,145,043.43
|
Pass
|
3
|
Current Year Budget YTD
|
99,135,613
|
99,135,613.26
|
Pass
|
4
|
Total Open Revenue
|
13,338,032
|
13,338,031.57
|
Pass
|
5
|
Total Shipped Current Year
|
127,704,928
|
127,704,927.83
|
Pass
|
6
|
Total Shipped Last Year
|
105,100,977
|
105,100,976.89
|
Pass
|
7
|
Total Budget Current Year
|
106,328,736
|
106,328,735.90
|
Pass
|
8
|
TY Quantity
|
11,347,447
|
11,347,447
|
Pass
|
9
|
LY Quantity
|
9,604,348
|
9,604,348
|
Pass
|
10
|
Budget Quantity
|
8,603,393
|
8,603,393
|
Pass
|
Grouping: North America > FootBall> United States Sales - YTD
SNo
|
Test Case
|
Value in Production Report
|
Value in Development Report
|
Pass/Fail
|
1
|
Current Year Shipped YTD
|
111,140,715
|
111,140,715.01
|
Pass
|
2
|
Last Year Shipped YTD
|
96,666,422
|
96,666,422.37
|
Pass
|
3
|
Current Year Budget YTD
|
95,118,439
|
95,118,438.87
|
Pass
|
4
|
Total Open Revenue
|
13,231,289
|
13,231,289.02
|
Pass
|
5
|
Total Shipped Current Year
|
124,372,004
|
124,372,004.03
|
Pass
|
6
|
Total Shipped Last Year
|
101,404,878
|
101,404,878.20
|
Pass
|
7
|
Total Budget Current Year
|
102,069,169
|
102,069,169.41
|
Pass
|
8
|
TY Quantity
|
11,009,396
|
11,009,396
|
Pass
|
9
|
LY Quantity
|
9,290,164
|
9,290,164
|
Pass
|
10
|
Budget Quantity
|
8,232,520
|
8,232,520
|
Pass
|
Grouping: North America - MTD
SNo
|
Test Case
|
Value in Production Report
|
Value in Development Report
|
Pass/Fail
|
1
|
Current Year Shipped MTD
|
35,538,426
|
35,538,425.61
|
Pass
|
2
|
Last Year Shipped MTD
|
30,171,707
|
30,171,707.1
|
Pass
|
3
|
Current Year Budget MTD
|
34,682,281
|
34,682,281
|
Pass
|
4
|
TY Quantity
|
3,593,948
|
3,593,948
|
Pass
|
5
|
LY Quantity
|
3,019,006
|
3,019,006
|
Pass
|
6
|
Budget Quantity
|
3,228,558
|
3,228,558
|
Pass
|
Grouping: North America > FootBall> MTD
SNo
|
Test Case
|
Value in Production Report
|
Value in Development Report
|
Pass/Fail
|
1
|
Current Year Shipped MTD
|
12,679,373
|
12,679,372.77
|
Pass
|
2
|
Last Year Shipped MTD
|
8,487,633
|
8,487,632.93
|
Pass
|
3
|
Current Year Budget MTD
|
0
|
0
|
Pass
|
4
|
TY Quantity
|
1,331,062
|
1,331,062
|
Pass
|
5
|
LY Quantity
|
816,234
|
816,234
|
Pass
|
6
|
Budget Quantity
|
0
|
0
|
Pass
|
Grouping: North America > FootBall> United States Sales - MTD
SNo
|
Test Case
|
Value in Production Report
|
Value in Development Report
|
Pass/Fail
|
1
|
Current Year Shipped MTD
|
12,466,064
|
12,466,064.24
|
Pass
|
2
|
Last Year Shipped MTD
|
8,237,661
|
8,237,661.28
|
Pass
|
3
|
Current Year Budget MTD
|
95,118,439
|
95,118,438.87
|
Pass
|
4
|
TY Quantity
|
1,309,085
|
1,309,085
|
Pass
|
5
|
LY Quantity
|
791,643
|
791,643
|
Pass
|
6
|
Budget Quantity
|
891,673
|
0
|
Pass
|
Product Mix Sub Report Validation
Test(s) Conducted
Parameter : 2 Grouping: North America > Headwear
SNo
|
Test Case
|
Value in Production Report
|
Value in Development Report
|
Pass/Fail
|
1
|
Current Year Shipped YTD
|
391,586,215
|
391,586,215.43
|
Pass
|
2
|
Open
|
84,054,781
|
84,054,781.07
|
Pass
|
3
|
Total Revenue YTD
|
475,640,997
|
475,640,996.50
|
Pass
|
4
|
Last Year Shipped YTD
|
376,590,115
|
376,590,115.22
|
Pass
|
5
|
Current Year Budget YTD
|
380,046,681
|
380,046,681
|
Pass
|
6
|
TY Quantity
|
39,435,686
|
39,435,686
|
Pass
|
7
|
LY Quantity
|
36,603,120
|
36,603,120
|
Pass
|
8
|
Budget Quantity
|
34,829,442
|
34,829,432
|
Pass
|
Grouping: North America >Football> Headwear - YTD
SNo
|
Test Case
|
Value in Production Report
|
Value in Development Report
|
Pass/Fail
|
1
|
Current Year Shipped YTD
|
114,366,896
|
114,366,896.26
|
Pass
|
2
|
Open
|
13,338,032
|
13,338,031.57
|
Pass
|
3
|
Total Revenue YTD
|
127,704,928
|
127,704,927.83
|
Pass
|
4
|
Last Year Shipped YTD
|
100,145,043
|
100,145,043.43
|
Pass
|
5
|
Current Year Budget YTD
|
99,135,613
|
99,135,613
|
Pass
|
6
|
TY Quantity
|
11,340,756
|
11,340,756
|
Pass
|
7
|
LY Quantity
|
9,604,348
|
9,604,348
|
Pass
|
8
|
Budget Quantity
|
8,603,394
|
8,603,393
|
Pass
|
Grouping: North America > Headwear - MTD
SNo
|
Test Case
|
Value in Production Report
|
Value in Development report
|
Pass/Fail
|
1
|
Current Year Shipped MTD
|
33,294,141
|
33,294,140.95
|
Pass
|
2
|
Open
|
1,719,526
|
1,719,526.09
|
Pass
|
3
|
Total Revenue MTD
|
35,013,667
|
35,013,667.04
|
Pass
|
4
|
Last Year Shipped MTD
|
28,343,484
|
28,343,483.52
|
Pass
|
5
|
Current Year Budget MTD
|
0
|
0
|
Pass
|
6
|
TY Quantity
|
3,409,383
|
3,409,383
|
Pass
|
7
|
LY Quantity
|
2,861,210
|
2,861,210
|
Pass
|
8
|
Budget Quantity
|
0
|
0
|
Pass
|
Grouping: North America >Football> Headwear - MTD
SNo
|
Test Case
|
Value in Production Report
|
Value in Development Report
|
Pass/Fail
|
1
|
Current Year Shipped MTD
|
12,679,373
|
12,679,372.77
|
Pass
|
2
|
Open
|
209,890
|
209,890.14
|
Pass
|
3
|
Total Revenue MTD
|
12,889,263
|
12,889,262.91
|
Pass
|
4
|
Last Year Shipped MTD
|
8,487,633
|
8,487,632.93
|
Pass
|
5
|
Current Year Budget MTD
|
0
|
0
|
Pass
|
6
|
TY Quantity
|
1,331,062
|
1,331,062
|
Pass
|
7
|
LY Quantity
|
816,234
|
816,234
|
Pass
|
8
|
Budget Quantity
|
0
|
0
|
Pass
|
Grouping: North America >Football> United State Sales -Headwear - YTD
SNo
|
Test Case
|
Value in Production Report
|
Value in Development Report
|
Pass/Fail
|
1
|
Current Year Shipped YTD
|
111,140,715
|
111,140,715.01
|
Pass
|
2
|
Open
|
13,231,289
|
13,231,289.02
|
Pass
|
3
|
Total Revenue YTD
|
124,372,004
|
124,372,004.03
|
Pass
|
4
|
Last Year Shipped YTD
|
96,666,422
|
96,666,422.37
|
Pass
|
5
|
Current Year Budget YTD
|
95,118,439
|
95,118,438.87
|
Pass
|
6
|
TY Quantity
|
11,009,248
|
11,009,248
|
Pass
|
7
|
LY Quantity
|
9,290,164
|
9,290,164
|
Pass
|
8
|
Budget Quantity
|
8,232,520
|
8,232,520
|
Pass
|
Grouping: North America > FootBall> United States Sales - Headwear - MTD
SNo
|
Test Case
|
Value in Production Report
|
Value in Development Report
|
Pass/Fail
|
1
|
Current Year Shipped MTD
|
12,466,064
|
12,466,064.24
|
Pass
|
2
|
Open
|
101,193
|
101,192.51
|
Pass
|
3
|
Total Revenue MTD
|
12,567,257
|
12,567,256.75
|
Pass
|
4
|
Last Year Shipped MTD
|
8,237,661
|
8,237,661.28
|
Pass
|
5
|
Current Year Budget MTD
|
0
|
0
|
Pass
|
6
|
TY Quantity
|
1,309,085
|
1,309,085
|
Pass
|
7
|
LY Quantity
|
791,643
|
791,643
|
Pass
|
8
|
Budget Quantity
|
0
|
0
|
Pass
|
Customer Segment Sub Report Validation
Test(s) Conducted
Parameter : 3 Grouping: North America > Sporting Goods
SNo
|
Test Case
|
Value in Production Report
|
Value in Development Report
|
Pass/Fail
|
1
|
Current Year Shipped YTD
|
55,943
|
55,942.63
|
Pass
|
2
|
Open
|
11,230
|
11,229.50
|
Pass
|
3
|
Total Revenue YTD
|
67,172
|
67,172.13
|
Pass
|
4
|
Last Year Shipped YTD
|
6,415
|
6,415.25
|
Pass
|
5
|
Current Year Budget YTD
|
0
|
0
|
Pass
|
6
|
TY Quantity
|
4,060
|
4,060
|
Pass
|
7
|
LY Quantity
|
484
|
484
|
Pass
|
8
|
Budget Quantity
|
0
|
0
|
Pass
|
Grouping: North America >Football - Sporting Goods - YTD
SNo
|
Test Case
|
Value in Production Report
|
Value in Development Report
|
Pass/Fail
|
1
|
Current Year Shipped YTD
|
21,740
|
21,739.90
|
Pass
|
2
|
Open
|
4,456
|
4,455.50
|
Pass
|
3
|
Total Revenue YTD
|
26,195
|
26,195.40
|
Pass
|
4
|
Last Year Shipped YTD
|
5,415
|
5,414.50
|
Pass
|
5
|
Current Year Budget YTD
|
0
|
0
|
Pass
|
6
|
TY Quantity
|
1,623
|
1,623
|
Pass
|
7
|
LY Quantity
|
405
|
405
|
Pass
|
8
|
Budget Quantity
|
0
|
0
|
Pass
|
Grouping: North America > SG - MTD
SNo
|
Test Case
|
Value in Production Report
|
Value in Development Report
|
Pass/Fail
|
1
|
Current Year Shipped MTD
|
11,741,074
|
11,741,073.96
|
Pass
|
2
|
Open
|
615,571
|
615,571.27
|
Pass
|
3
|
Total Revenue MTD
|
12,356,645
|
12,356,645.23
|
Pass
|
4
|
Last Year Shipped MTD
|
8,502,654
|
8,502,654.42
|
Pass
|
5
|
Current Year Budget MTD
|
0
|
0
|
Pass
|
6
|
TY Quantity
|
950,688
|
950,688
|
Pass
|
7
|
LY Quantity
|
712,597
|
712,597
|
Pass
|
8
|
Budget Quantity
|
0
|
0
|
Pass
|
Grouping: North America >Football - Sporting Goods - MTD
SNo
|
Test Case
|
Value in Production Report
|
Value in Development Report
|
Pass/Fail
|
1
|
Current Year Shipped MTD
|
1,104
|
1,104.00
|
Pass
|
2
|
Open
|
0
|
0
|
Pass
|
3
|
Total Revenue MTD
|
1,104
|
1,104.00
|
Pass
|
4
|
Last Year Shipped MTD
|
330
|
330.00
|
Pass
|
5
|
Current Year Budget MTD
|
0
|
0
|
Pass
|
6
|
TY Quantity
|
96
|
96
|
Pass
|
7
|
LY Quantity
|
30
|
30
|
Pass
|
8
|
Budget Quantity
|
0
|
0
|
Pass
|
Grouping: North America >Football> United State Sales - Sporting Goods - YTD
SNo
|
Test Case
|
Value in Production Report
|
Value in Development Report
|
Pass/Fail
|
1
|
Current Year Shipped YTD
|
21,740
|
21,739.90
|
Pass
|
2
|
Open
|
4,456
|
4,455.50
|
Pass
|
3
|
Total Revenue YTD
|
26,195
|
26,195.40
|
Pass
|
4
|
Last Year Shipped YTD
|
5,415
|
5,414.50
|
Pass
|
5
|
Current Year Budget YTD
|
0
|
0
|
Pass
|
6
|
TY Quantity
|
1,623
|
1,623
|
Pass
|
7
|
LY Quantity
|
405
|
405
|
Pass
|
8
|
Budget Quantity
|
0
|
0
|
Pass
|
Grouping: North America > FootBall> United States Sales - Sporting Goods - MTD
SNo
|
Test Case
|
Value in Production Report
|
Value in Development Report
|
Pass/Fail
|
1
|
Current Year Shipped MTD
|
1,104
|
1,104.00
|
Pass
|
2
|
Open
|
0
|
0
|
Pass
|
3
|
Total Revenue MTD
|
1,104
|
1,104.00
|
Pass
|
4
|
Last Year Shipped MTD
|
1,104
|
1,104.00
|
Pass
|
5
|
Current Year Budget MTD
|
0
|
0
|
Pass
|
6
|
TY Quantity
|
96
|
96
|
Pass
|
7
|
LY Quantity
|
30
|
30
|
Pass
|
8
|
Budget Quantity
|
0
|
0
|
Pass
|
License Sub Report Validation
Test(s) Conducted
Parameter : 3 Grouping: North America > Minor League
SNo
|
Test Case
|
Value in Production Report
|
Value in Development Report
|
Pass/Fail
|
1
|
Current Year Shipped YTD
|
6,224,416
|
6,224,415.73
|
Pass
|
2
|
Open
|
3,396,271
|
3,396,271.13
|
Pass
|
3
|
Total Revenue YTD
|
9,620,687
|
9,620,686.86
|
Pass
|
4
|
Last Year Shipped YTD
|
5,258,299
|
5,258,298.92
|
Pass
|
5
|
Current Year Budget YTD
|
0
|
0
|
Pass
|
6
|
TY Quantity
|
583,092
|
583,092
|
Pass
|
7
|
LY Quantity
|
507,409
|
507,409
|
Pass
|
8
|
Budget Quantity
|
0
|
0
|
Pass
|
Grouping: North America >Football - MLB Properties - YTD
SNo
|
Test Case
|
Value in Production Report
|
Value in Development Report
|
Pass/Fail
|
1
|
Current Year Shipped YTD
|
4,320
|
4,320
|
Pass
|
2
|
Open
|
0
|
0
|
Pass
|
3
|
Total Revenue YTD
|
4,320
|
4,320
|
Pass
|
4
|
Last Year Shipped YTD
|
0
|
0
|
Pass
|
5
|
Current Year Budget YTD
|
0
|
0
|
Pass
|
6
|
TY Quantity
|
432
|
432
|
Pass
|
7
|
LY Quantity
|
0
|
0
|
Pass
|
8
|
Budget Quantity
|
0
|
0
|
Pass
|
Grouping: North America > Minor League - MTD
SNo
|
Test Case
|
Value in Production Report
|
Value in Development Report
|
Pass/Fail
|
1
|
Current Year Shipped MTD
|
214,994
|
214,993.77
|
Pass
|
2
|
Open
|
0
|
0
|
Pass
|
3
|
Total Revenue MTD
|
214,994
|
214,993.77
|
Pass
|
4
|
Last Year Shipped MTD
|
124,942
|
124,942.35
|
Pass
|
5
|
Current Year Budget MTD
|
0
|
0
|
Pass
|
6
|
TY Quantity
|
18,589
|
18,589
|
Pass
|
7
|
LY Quantity
|
12,132
|
12,132
|
Pass
|
8
|
Budget Quantity
|
0
|
0
|
Pass
|
Grouping: North America >Football - Canadian football - MTD
SNo
|
Test Case
|
Value in Production Report
|
Value in Development Report
|
Pass/Fail
|
1
|
Current Year Shipped MTD
|
56,319
|
56,318.60
|
Pass
|
2
|
Open
|
0
|
0
|
Pass
|
3
|
Total Revenue MTD
|
56,319
|
56,318.60
|
Pass
|
4
|
Last Year Shipped MTD
|
-2,897
|
-2,896.80
|
Pass
|
5
|
Current Year Budget MTD
|
0
|
0
|
Pass
|
6
|
TY Quantity
|
5,473
|
5,473
|
Pass
|
7
|
LY Quantity
|
-59
|
-59
|
Pass
|
8
|
Budget Quantity
|
0
|
0
|
Pass
|
Grouping: North America >Football> United State Sales - Canadian Football - YTD
SNo
|
Test Case
|
Value in Production Report
|
Value in Development Report
|
Pass/Fail
|
1
|
Current Year Shipped YTD
|
102
|
101.62
|
Pass
|
2
|
Open
|
133
|
132.79
|
Pass
|
3
|
Total Revenue YTD
|
234
|
234.41
|
Pass
|
4
|
Last Year Shipped YTD
|
99
|
98.56
|
Pass
|
5
|
Current Year Budget YTD
|
0
|
0
|
Pass
|
6
|
TY Quantity
|
32
|
32
|
Pass
|
7
|
LY Quantity
|
22
|
22
|
Pass
|
8
|
Budget Quantity
|
0
|
0
|
Pass
|
Grouping: North America > FootBall> United States Sales - NFL Properties - MTD
SNo
|
Test Case
|
Value in Production Report
|
Value in Development Report
|
Pass/Fail
|
1
|
Current Year Shipped MTD
|
12,408,422
|
12,408,421.84
|
Pass
|
2
|
Open
|
101,193
|
101,192.51
|
Pass
|
3
|
Total Revenue MTD
|
12,509,614
|
12,509,614.35
|
Pass
|
4
|
Last Year Shipped MTD
|
8,237,661
|
8,237,661.28
|
Pass
|
5
|
Current Year Budget MTD
|
0
|
0
|
Pass
|
6
|
TY Quantity
|
1,304,277
|
1,304,277
|
Pass
|
7
|
LY Quantity
|
791,643
|
791,643
|
Pass
|
8
|
Budget Quantity
|
0
|
0
|
Pass
|
Customer Sub Report Validation
Test(s) Conducted
Parameter : 4 Grouping: North America > SANMAR
SNo
|
Test Case
|
Value in Production Report
|
Value in Development Report
|
Pass/Fail
|
1
|
Current Year Shipped YTD
|
7,404,946
|
7,404,946.44
|
Pass
|
2
|
Open
|
3,333,928
|
3,333,927.96
|
Pass
|
3
|
Total Revenue YTD
|
10,738,874
|
10,738,874.40
|
Pass
|
4
|
Last Year Shipped YTD
|
6,268,695
|
6,268,695.41
|
Pass
|
5
|
Current Year Budget YTD
|
0
|
0
|
Pass
|
6
|
TY Quantity
|
2,178,427
|
2,178,427
|
Pass
|
7
|
LY Quantity
|
1,917,246
|
1,917,246
|
Pass
|
8
|
Budget Quantity
|
0
|
0
|
Pass
|
Grouping: North America >Football - Ross Stores Inc - YTD
SNo
|
Test Case
|
Value in Production Report
|
Value in Development Report
|
Pass/Fail
|
1
|
Current Year Shipped YTD
|
2,709,928
|
2,709,928.14
|
Pass
|
2
|
Open
|
604,537
|
604,536.50
|
Pass
|
3
|
Total Revenue YTD
|
3,314,465
|
3,314,464.64
|
Pass
|
4
|
Last Year Shipped YTD
|
2,011,364
|
2,011,364.20
|
Pass
|
5
|
Current Year Budget YTD
|
0
|
0
|
Pass
|
6
|
TY Quantity
|
557,740
|
557,740
|
Pass
|
7
|
LY Quantity
|
523,236
|
523,236
|
Pass
|
8
|
Budget Quantity
|
0
|
0
|
Pass
|
Grouping: North America > Hatworld DIV OF - MTD
SNo
|
Test Case
|
Value in Production Report
|
Value in Development Report
|
Pass/Fail
|
1
|
Current Year Shipped MTD
|
997,363
|
997,362.66
|
Pass
|
2
|
Open
|
7,286
|
7,285.50
|
Pass
|
3
|
Total Revenue MTD
|
1,004,648
|
1,004,648.16
|
Pass
|
4
|
Last Year Shipped MTD
|
525,178
|
525,177.78
|
Pass
|
5
|
Current Year Budget MTD
|
0
|
0
|
Pass
|
6
|
TY Quantity
|
99,459
|
99,459
|
Pass
|
7
|
LY Quantity
|
55,951
|
55,951
|
Pass
|
8
|
Budget Quantity
|
0
|
0
|
Pass
|
Grouping: North America >Football - Kohls Com - MTD
SNo
|
Test Case
|
Value in Production Report
|
Value in Development Report
|
Pass/Fail
|
1
|
Current Year Shipped MTD
|
231,964
|
231,964.14
|
Pass
|
2
|
Open
|
0
|
0
|
Pass
|
3
|
Total Revenue MTD
|
231,964
|
231,964.14
|
Pass
|
4
|
Last Year Shipped MTD
|
0
|
0
|
Pass
|
5
|
Current Year Budget MTD
|
0
|
0
|
Pass
|
6
|
TY Quantity
|
20,928
|
20,928
|
Pass
|
7
|
LY Quantity
|
0
|
0
|
Pass
|
8
|
Budget Quantity
|
0
|
0
|
Pass
|
Grouping: North America >Football> United State Sales - Amazon Com Inc - YTD
SNo
|
Test Case
|
Value in Production Report
|
Value in Development Report
|
Pass/Fail
|
1
|
Current Year Shipped YTD
|
2,612,198
|
2,612,198.30
|
Pass
|
2
|
Open
|
284,428
|
284,427.50
|
Pass
|
3
|
Total Revenue YTD
|
2,896,626
|
2,896,625.80
|
Pass
|
4
|
Last Year Shipped YTD
|
2,092,179
|
2,092,179.37
|
Pass
|
5
|
Current Year Budget YTD
|
2,200,026
|
2,200,026.22
|
Pass
|
6
|
TY Quantity
|
213,940
|
213,940
|
Pass
|
7
|
LY Quantity
|
163,239
|
163,239
|
Pass
|
8
|
Budget Quantity
|
160,115
|
160,114
|
Pass
|
Grouping: North America > FootBall> United States Sales - Fanatics Inc - MTD
SNo
|
Test Case
|
Value in Production Report
|
Value in Development Report
|
Pass/Fail
|
1
|
Current Year Shipped MTD
|
582,059
|
582,058.86
|
Pass
|
2
|
Open
|
0
|
0
|
Pass
|
3
|
Total Revenue MTD
|
582,059
|
582.058.86
|
Pass
|
4
|
Last Year Shipped MTD
|
544,819
|
544.819.24
|
Pass
|
5
|
Current Year Budget MTD
|
0
|
0
|
Pass
|
6
|
TY Quantity
|
46,144
|
46,144
|
Pass
|
7
|
LY Quantity
|
50,751
|
50,751
|
Pass
|
8
|
Budget Quantity
|
0
|
0
|
Pass
|
Silhouette Sub Report Validation
Test(s) Conducted
Parameter : 5 Grouping: North America > Visor
SNo
|
Test Case
|
Value in Production Report
|
Value in Development Report
|
Pass/Fail
|
1
|
Current Year Shipped YTD
|
1,753,908
|
1,753,907.85
|
Pass
|
2
|
Open
|
836,067
|
836,067.43
|
Pass
|
3
|
Total Revenue YTD
|
2,589,975
|
2,589,975.28
|
Pass
|
4
|
Last Year Shipped YTD
|
1,665,649
|
1,665,649.02
|
Pass
|
5
|
Current Year Budget YTD
|
0
|
0
|
Pass
|
6
|
TY Quantity
|
211,136
|
211,136
|
Pass
|
7
|
LY Quantity
|
207,072
|
207,072
|
Pass
|
8
|
Budget Quantity
|
0
|
0
|
Pass
|
Grouping: North America >Football - Running - YTD
SNo
|
Test Case
|
Value in Production Report
|
Value in Development Report
|
Pass/Fail
|
1
|
Current Year Shipped YTD
|
95,568
|
95,568.46
|
Pass
|
2
|
Open
|
32,353
|
32,352.74
|
Pass
|
3
|
Total Revenue YTD
|
127,921
|
127,921.20
|
Pass
|
4
|
Last Year Shipped YTD
|
66,450
|
66,450.20
|
Pass
|
5
|
Current Year Budget YTD
|
0
|
0
|
Pass
|
6
|
TY Quantity
|
15,633
|
15,633
|
Pass
|
7
|
LY Quantity
|
10,223
|
10,223
|
Pass
|
8
|
Budget Quantity
|
0
|
0
|
Pass
|
Grouping: North America > Bucket - MTD
SNo
|
Test Case
|
Value in Production Report
|
Value in Development Report
|
Pass/Fail
|
1
|
Current Year Shipped MTD
|
60,288
|
60,288.04
|
Pass
|
2
|
Open
|
3,345
|
3,344.79
|
Pass
|
3
|
Total Revenue MTD
|
63,633
|
63,632.83
|
Pass
|
4
|
Last Year Shipped MTD
|
392,504
|
392,504
|
Pass
|
5
|
Current Year Budget MTD
|
0
|
0
|
Pass
|
6
|
TY Quantity
|
11,098
|
11,098
|
Pass
|
7
|
LY Quantity
|
37,972
|
37,972
|
Pass
|
8
|
Budget Quantity
|
0
|
0
|
Pass
|
Grouping: North America >Football - Bucket - MTD
SNo
|
Test Case
|
Value in Production Report
|
Value in Development Report
|
Pass/Fail
|
1
|
Current Year Shipped MTD
|
46,489
|
46,489.02
|
Pass
|
2
|
Open
|
0
|
0
|
Pass
|
3
|
Total Revenue MTD
|
46,489
|
46,489.02
|
Pass
|
4
|
Last Year Shipped MTD
|
276,831
|
276,830.58
|
Pass
|
5
|
Current Year Budget MTD
|
0
|
0
|
Pass
|
6
|
TY Quantity
|
7,909
|
7,909
|
Pass
|
7
|
LY Quantity
|
27,884
|
27,884
|
Pass
|
8
|
Budget Quantity
|
0
|
0
|
Pass
|
Grouping: North America >Football> United State Sales - Running - YTD
SNo
|
Test Case
|
Value in Production Report
|
Value in Development Report
|
Pass/Fail
|
1
|
Current Year Shipped YTD
|
95,123
|
95,122.88
|
Pass
|
2
|
Open
|
32,313
|
32,312.97
|
Pass
|
3
|
Total Revenue YTD
|
127,436
|
127,435.85
|
Pass
|
4
|
Last Year Shipped YTD
|
66,427
|
66,426.62
|
Pass
|
5
|
Current Year Budget YTD
|
0
|
0
|
Pass
|
6
|
TY Quantity
|
15,599
|
15,599
|
Pass
|
7
|
LY Quantity
|
10,221
|
10,221
|
Pass
|
8
|
Budget Quantity
|
0
|
0
|
Pass
|
Grouping: North America > FootBall> United States Sales - 4940 - MTD
SNo
|
Test Case
|
Value in Production Report
|
Value in Development Report
|
Pass/Fail
|
1
|
Current Year Shipped MTD
|
6,096
|
6,096.00
|
Pass
|
2
|
Open
|
0
|
0
|
Pass
|
3
|
Total Revenue MTD
|
6,096
|
6,096.00
|
Pass
|
4
|
Last Year Shipped MTD
|
1,707
|
1,707.43
|
Pass
|
5
|
Current Year Budget MTD
|
0
|
0
|
Pass
|
6
|
TY Quantity
|
480
|
480
|
Pass
|
7
|
LY Quantity
|
153
|
153
|
Pass
|
8
|
Budget Quantity
|
0
|
0
|
Pass
|
Reference Document(Enhancement)
2015-11-18 - 23133 - Enhancement - Category scorecard update
2015-11-18 - 23133 - Rel Notes - Category scorecard update - Release 001